Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	129647
Missing cells	185379
Missing cells (%)	7.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	19.8 MiB
Average record size in memory	160.0 B

Variable types

Numeric	6
Categorical	5
Text	6
Unsupported	1
DateTime	2

Alerts

`Fiscal_Year` has constant value ""	Constant
`CheckVoidDt` has constant value ""	Constant
`ObjectId` is highly overall correlated with `Budget_Type` and 1 other fields	High correlation
`InvoiceID` is highly overall correlated with `CheckID`	High correlation
`InvoiceAmt` is highly overall correlated with `DistributionAmt` and 1 other fields	High correlation
`DistributionAmt` is highly overall correlated with `InvoiceAmt`	High correlation
`CheckID` is highly overall correlated with `InvoiceID`	High correlation
`CheckAmt` is highly overall correlated with `InvoiceAmt`	High correlation
`Budget_Type` is highly overall correlated with `ObjectId` and 1 other fields	High correlation
`Agency_Name` is highly overall correlated with `ObjectId` and 1 other fields	High correlation
`Budget_Type` is highly imbalanced (62.3%)	Imbalance
`Category` is highly imbalanced (61.1%)	Imbalance
`DepartmentName` has 10013 (7.7%) missing values	Missing
`Sub_DepartmentName` has 45703 (35.3%) missing values	Missing
`Stimulus_Type` has 129647 (100.0%) missing values	Missing
`InvoiceAmt` is highly skewed (γ1 = 47.65706828)	Skewed
`DistributionAmt` is highly skewed (γ1 = 110.28375)	Skewed
`CheckAmt` is highly skewed (γ1 = 20.69431244)	Skewed
`ObjectId` is uniformly distributed	Uniform
`ObjectId` has unique values	Unique
`Stimulus_Type` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-12-31 13:38:21.150927
Analysis finished	2023-12-31 13:38:38.993595
Duration	17.84 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

ObjectId
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	129647
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64824

Minimum	1
Maximum	129647
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1013.0 KiB

Quantile statistics

Minimum	1
5-th percentile	6483.3
Q1	32412.5
median	64824
Q3	97235.5
95-th percentile	123164.7
Maximum	129647
Range	129646
Interquartile range (IQR)	64823

Descriptive statistics

Standard deviation	37426.01
Coefficient of variation (CV)	0.57734804
Kurtosis	-1.2
Mean	64824
Median Absolute Deviation (MAD)	32412
Skewness	0
Sum	8.4042371 × 10⁹
Variance	1.4007062 × 10⁹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
86427	1	< 0.1%
86440	1	< 0.1%
86439	1	< 0.1%
86438	1	< 0.1%
86437	1	< 0.1%
86436	1	< 0.1%
86435	1	< 0.1%
86434	1	< 0.1%
86433	1	< 0.1%
Other values (129637)	129637	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
129647	1	< 0.1%
129646	1	< 0.1%
129645	1	< 0.1%
129644	1	< 0.1%
129643	1	< 0.1%
129642	1	< 0.1%
129641	1	< 0.1%
129640	1	< 0.1%
129639	1	< 0.1%
129638	1	< 0.1%

Fiscal_Year
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

2008	129647

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	518588
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2008
2nd row	2008
3rd row	2008
4th row	2008
5th row	2008

Common Values

Value	Count	Frequency (%)
2008	129647	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2008	129647	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	259294	50.0%
2	129647	25.0%
8	129647	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	518588	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	259294	50.0%
2	129647	25.0%
8	129647	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	518588	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	259294	50.0%
2	129647	25.0%
8	129647	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	518588	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	259294	50.0%
2	129647	25.0%
8	129647	25.0%

Budget_Type
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

Metro Government Operations	120167
Metro Government Capital	9480

Length

Max length	27
Median length	27
Mean length	26.780635
Min length	24

Characters and Unicode

Total characters	3472029
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Metro Government Capital
2nd row	Metro Government Capital
3rd row	Metro Government Capital
4th row	Metro Government Capital
5th row	Metro Government Capital

Common Values

Value	Count	Frequency (%)
Metro Government Operations	120167	92.7%
Metro Government Capital	9480	7.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
metro	129647	33.3%
government	129647	33.3%
operations	120167	30.9%
capital	9480	2.4%

Most occurring characters

Value	Count	Frequency (%)
e	509108	14.7%
t	388941	11.2%
n	379461	10.9%
r	379461	10.9%
o	379461	10.9%
	259294	7.5%
a	139127	4.0%
p	129647	3.7%
i	129647	3.7%
M	129647	3.7%
Other values (7)	648235	18.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2823794	81.3%
Uppercase Letter	388941	11.2%
Space Separator	259294	7.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	509108	18.0%
t	388941	13.8%
n	379461	13.4%
r	379461	13.4%
o	379461	13.4%
a	139127	4.9%
p	129647	4.6%
i	129647	4.6%
m	129647	4.6%
v	129647	4.6%
Other values (2)	129647	4.6%

Uppercase Letter

Value	Count	Frequency (%)
M	129647	33.3%
G	129647	33.3%
O	120167	30.9%
C	9480	2.4%

Space Separator

Value	Count	Frequency (%)
	259294	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3212735	92.5%
Common	259294	7.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	509108	15.8%
t	388941	12.1%
n	379461	11.8%
r	379461	11.8%
o	379461	11.8%
a	139127	4.3%
p	129647	4.0%
i	129647	4.0%
M	129647	4.0%
m	129647	4.0%
Other values (6)	518588	16.1%

Common

Value	Count	Frequency (%)
	259294	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3472029	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	509108	14.7%
t	388941	11.2%
n	379461	10.9%
r	379461	10.9%
o	379461	10.9%
	259294	7.5%
a	139127	4.0%
p	129647	3.7%
i	129647	3.7%
M	129647	3.7%
Other values (7)	648235	18.7%

Agency_Name
Categorical

HIGH CORRELATION

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

Related Agencies	25738
Public Works & Assets Department	21290
Public Protection Department	15976
Parks & Recreation	14046
Housing & Family Services	12589
Other values (25)	40008

Length

Max length	37
Median length	29
Mean length	22.128372
Min length	7

Characters and Unicode

Total characters	2868877
Distinct characters	45
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Waterfront Development Corp
2nd row	Waterfront Development Corp
3rd row	Waterfront Development Corp
4th row	Waterfront Development Corp
5th row	Waterfront Development Corp

Common Values

Value	Count	Frequency (%)
Related Agencies	25738	19.9%
Public Works & Assets Department	21290	16.4%
Public Protection Department	15976	12.3%
Parks & Recreation	14046	10.8%
Housing & Family Services	12589	9.7%
Elected Officials	8397	6.5%
Metro Police	8117	6.3%
Public Health & Wellness	7401	5.7%
Economic Development	3564	2.7%
Neighborhoods Department	2700	2.1%
Other values (20)	9829	7.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	58273	14.5%
public	44667	11.1%
department	43429	10.8%
related	25738	6.4%
agencies	25738	6.4%
works	21290	5.3%
assets	21290	5.3%
protection	15976	4.0%
parks	14046	3.5%
recreation	14046	3.5%
Other values (46)	116440	29.0%

Most occurring characters

Value	Count	Frequency (%)
e	368393	12.8%
	271286	9.5%
t	214331	7.5%
s	185564	6.5%
i	177886	6.2%
c	153553	5.4%
r	140648	4.9%
l	140218	4.9%
n	136550	4.8%
a	132807	4.6%
Other values (35)	947641	33.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2196350	76.6%
Uppercase Letter	342297	11.9%
Space Separator	271286	9.5%
Other Punctuation	58944	2.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	368393	16.8%
t	214331	9.8%
s	185564	8.4%
i	177886	8.1%
c	153553	7.0%
r	140648	6.4%
l	140218	6.4%
n	136550	6.2%
a	132807	6.0%
o	130318	5.9%
Other values (11)	416082	18.9%

Uppercase Letter

Value	Count	Frequency (%)
P	82976	24.2%
D	47221	13.8%
A	47178	13.8%
R	43199	12.6%
W	28905	8.4%
H	21470	6.3%
S	14270	4.2%
F	12724	3.7%
E	12138	3.5%
M	12029	3.5%
Other values (10)	20187	5.9%

Other Punctuation

Value	Count	Frequency (%)
&	58063	98.5%
'	533	0.9%
/	348	0.6%

Space Separator

Value	Count	Frequency (%)
	271286	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2538647	88.5%
Common	330230	11.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	368393	14.5%
t	214331	8.4%
s	185564	7.3%
i	177886	7.0%
c	153553	6.0%
r	140648	5.5%
l	140218	5.5%
n	136550	5.4%
a	132807	5.2%
o	130318	5.1%
Other values (31)	758379	29.9%

Common

Value	Count	Frequency (%)
	271286	82.2%
&	58063	17.6%
'	533	0.2%
/	348	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2868877	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	368393	12.8%
	271286	9.5%
t	214331	7.5%
s	185564	6.5%
i	177886	6.2%
c	153553	5.4%
r	140648	4.9%
l	140218	4.9%
n	136550	4.8%
a	132807	4.6%
Other values (35)	947641	33.0%

Sub_Agency_Name
Text

Distinct	580
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

Length

Max length	81
Median length	66
Mean length	21.244178
Min length	3

Characters and Unicode

Total characters	2754244
Distinct characters	72
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	125 ?
Unique (%)	0.1%

Sample

1st row	Belle Capital Improvements
2nd row	Belle Capital Improvements
3rd row	Belle Capital Improvements
4th row	Belle Capital Improvements
5th row	Belle Capital Improvements

Value	Count	Frequency (%)
	31531	9.1%
services	16453	4.7%
division	14589	4.2%
facilities	13338	3.8%
fleet	13321	3.8%
louisville	13040	3.8%
library	10272	3.0%
metro	8380	2.4%
zoo	8153	2.3%
operations	7528	2.2%
Other values (1012)	210835	60.7%

Most occurring characters

Value	Count	Frequency (%)
i	276398	10.0%
e	273408	9.9%
	217793	7.9%
o	185323	6.7%
t	183723	6.7%
n	169949	6.2%
r	168732	6.1%
a	147685	5.4%
s	147394	5.4%
l	112343	4.1%
Other values (62)	871496	31.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2128120	77.3%
Uppercase Letter	344852	12.5%
Space Separator	217793	7.9%
Other Punctuation	40829	1.5%
Decimal Number	17424	0.6%
Dash Punctuation	5104	0.2%
Open Punctuation	61	< 0.1%
Close Punctuation	61	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	276398	13.0%
e	273408	12.8%
o	185323	8.7%
t	183723	8.6%
n	169949	8.0%
r	168732	7.9%
a	147685	6.9%
s	147394	6.9%
l	112343	5.3%
c	89526	4.2%
Other values (16)	373639	17.6%

Uppercase Letter

Value	Count	Frequency (%)
F	42345	12.3%
S	35332	10.2%
D	33570	9.7%
P	28725	8.3%
M	27034	7.8%
L	25420	7.4%
C	19183	5.6%
A	18892	5.5%
E	16846	4.9%
O	16099	4.7%
Other values (16)	81406	23.6%

Decimal Number

Value	Count	Frequency (%)
0	5834	33.5%
1	4254	24.4%
2	3110	17.8%
8	2367	13.6%
4	715	4.1%
6	391	2.2%
7	354	2.0%
5	321	1.8%
9	48	0.3%
3	30	0.2%

Other Punctuation

Value	Count	Frequency (%)
&	31445	77.0%
/	3763	9.2%
,	3166	7.8%
'	1822	4.5%
.	623	1.5%
?	10	< 0.1%

Space Separator

Value	Count	Frequency (%)
	217793	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5104	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	61	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	61	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2472972	89.8%
Common	281272	10.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	276398	11.2%
e	273408	11.1%
o	185323	7.5%
t	183723	7.4%
n	169949	6.9%
r	168732	6.8%
a	147685	6.0%
s	147394	6.0%
l	112343	4.5%
c	89526	3.6%
Other values (42)	718491	29.1%

Common

Value	Count	Frequency (%)
	217793	77.4%
&	31445	11.2%
0	5834	2.1%
-	5104	1.8%
1	4254	1.5%
/	3763	1.3%
,	3166	1.1%
2	3110	1.1%
8	2367	0.8%
'	1822	0.6%
Other values (10)	2614	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2754244	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	276398	10.0%
e	273408	9.9%
	217793	7.9%
o	185323	6.7%
t	183723	6.7%
n	169949	6.2%
r	168732	6.1%
a	147685	5.4%
s	147394	5.4%
l	112343	4.1%
Other values (62)	871496	31.6%

DepartmentName
Text

MISSING

Distinct	251
Distinct (%)	0.2%
Missing	10013
Missing (%)	7.7%
Memory size	1013.0 KiB

Length

Max length	50
Median length	35
Mean length	17.826772
Min length	3

Characters and Unicode

Total characters	2132688
Distinct characters	68
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	< 0.1%

Sample

1st row	Metro Council Operations
2nd row	Metro Council Operations
3rd row	Metro Council Operations
4th row	Metro Council Operations
5th row	Metro Council Operations

Value	Count	Frequency (%)
services	20784	7.6%
	13186	4.8%
administration	9077	3.3%
facilities	8895	3.2%
management	8840	3.2%
finance	8056	2.9%
maintenance	7283	2.7%
collection	6654	2.4%
fleet	5934	2.2%
of	5799	2.1%
Other values (319)	180223	65.6%

Most occurring characters

Value	Count	Frequency (%)
e	216847	10.2%
i	206035	9.7%
n	185302	8.7%
	155097	7.3%
t	138946	6.5%
a	132516	6.2%
o	114461	5.4%
r	113779	5.3%
s	109314	5.1%
c	96252	4.5%
Other values (58)	664139	31.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1678982	78.7%
Uppercase Letter	269562	12.6%
Space Separator	155097	7.3%
Other Punctuation	18835	0.9%
Decimal Number	7992	0.4%
Open Punctuation	1095	0.1%
Close Punctuation	1095	0.1%
Dash Punctuation	30	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	216847	12.9%
i	206035	12.3%
n	185302	11.0%
t	138946	8.3%
a	132516	7.9%
o	114461	6.8%
r	113779	6.8%
s	109314	6.5%
c	96252	5.7%
l	79875	4.8%
Other values (16)	285655	17.0%

Uppercase Letter

Value	Count	Frequency (%)
F	32838	12.2%
S	32814	12.2%
A	28766	10.7%
C	23207	8.6%
P	19303	7.2%
M	18998	7.0%
O	14987	5.6%
B	14333	5.3%
R	12609	4.7%
D	11674	4.3%
Other values (14)	60033	22.3%

Decimal Number

Value	Count	Frequency (%)
1	3474	43.5%
9	1182	14.8%
2	1003	12.6%
0	910	11.4%
3	533	6.7%
5	301	3.8%
4	212	2.7%
6	210	2.6%
8	90	1.1%
7	77	1.0%

Other Punctuation

Value	Count	Frequency (%)
&	13186	70.0%
'	2704	14.4%
/	2294	12.2%
,	651	3.5%

Space Separator

Value	Count	Frequency (%)
	155097	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1095	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1095	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	30	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1948544	91.4%
Common	184144	8.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	216847	11.1%
i	206035	10.6%
n	185302	9.5%
t	138946	7.1%
a	132516	6.8%
o	114461	5.9%
r	113779	5.8%
s	109314	5.6%
c	96252	4.9%
l	79875	4.1%
Other values (40)	555217	28.5%

Common

Value	Count	Frequency (%)
	155097	84.2%
&	13186	7.2%
1	3474	1.9%
'	2704	1.5%
/	2294	1.2%
9	1182	0.6%
(	1095	0.6%
)	1095	0.6%
2	1003	0.5%
0	910	0.5%
Other values (8)	2104	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2132688	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	216847	10.2%
i	206035	9.7%
n	185302	8.7%
	155097	7.3%
t	138946	6.5%
a	132516	6.2%
o	114461	5.4%
r	113779	5.3%
s	109314	5.1%
c	96252	4.5%
Other values (58)	664139	31.1%

Sub_DepartmentName
Text

MISSING

Distinct	394
Distinct (%)	0.5%
Missing	45703
Missing (%)	35.3%
Memory size	1013.0 KiB

Length

Max length	40
Median length	34
Mean length	17.905878
Min length	4

Characters and Unicode

Total characters	1503091
Distinct characters	66
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	< 0.1%

Sample

1st row	DOH Administration
2nd row	DOH Administration
3rd row	DOH Administration
4th row	DOH Administration
5th row	DOH Administration

Value	Count	Frequency (%)
services	16867	9.2%
management	12208	6.6%
	11123	6.0%
facilities	8891	4.8%
maintenance	6669	3.6%
operations	6112	3.3%
fleet	5934	3.2%
administration	4705	2.6%
library	3429	1.9%
materials	3266	1.8%
Other values (554)	105113	57.0%

Most occurring characters

Value	Count	Frequency (%)
e	172740	11.5%
i	142579	9.5%
n	127650	8.5%
a	114062	7.6%
t	106232	7.1%
	100373	6.7%
r	93154	6.2%
s	74456	5.0%
o	63938	4.3%
c	60468	4.0%
Other values (56)	447439	29.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1197265	79.7%
Uppercase Letter	190049	12.6%
Space Separator	100373	6.7%
Other Punctuation	14673	1.0%
Dash Punctuation	384	< 0.1%
Open Punctuation	126	< 0.1%
Close Punctuation	115	< 0.1%
Decimal Number	106	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	172740	14.4%
i	142579	11.9%
n	127650	10.7%
a	114062	9.5%
t	106232	8.9%
r	93154	7.8%
s	74456	6.2%
o	63938	5.3%
c	60468	5.1%
l	52801	4.4%
Other values (16)	189185	15.8%

Uppercase Letter

Value	Count	Frequency (%)
S	31874	16.8%
M	26330	13.9%
F	20076	10.6%
A	15285	8.0%
P	14306	7.5%
C	12787	6.7%
O	10788	5.7%
D	9198	4.8%
B	7934	4.2%
I	7308	3.8%
Other values (15)	34163	18.0%

Decimal Number

Value	Count	Frequency (%)
0	45	42.5%
7	36	34.0%
3	15	14.2%
4	5	4.7%
1	4	3.8%
6	1	0.9%

Other Punctuation

Value	Count	Frequency (%)
&	10673	72.7%
/	2757	18.8%
'	735	5.0%
.	256	1.7%
,	252	1.7%

Space Separator

Value	Count	Frequency (%)
	100373	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	384	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	126	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	115	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1387314	92.3%
Common	115777	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	172740	12.5%
i	142579	10.3%
n	127650	9.2%
a	114062	8.2%
t	106232	7.7%
r	93154	6.7%
s	74456	5.4%
o	63938	4.6%
c	60468	4.4%
l	52801	3.8%
Other values (41)	379234	27.3%

Common

Value	Count	Frequency (%)
	100373	86.7%
&	10673	9.2%
/	2757	2.4%
'	735	0.6%
-	384	0.3%
.	256	0.2%
,	252	0.2%
(	126	0.1%
)	115	0.1%
0	45	< 0.1%
Other values (5)	61	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1503091	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	172740	11.5%
i	142579	9.5%
n	127650	8.5%
a	114062	7.6%
t	106232	7.1%
	100373	6.7%
r	93154	6.2%
s	74456	5.0%
o	63938	4.3%
c	60468	4.0%
Other values (56)	447439	29.8%

Category
Categorical

IMBALANCE

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

Contractual Services	76627
Supplies	49363
Equipment/Capital Outlay	1729
Interdepartment Charges	1431
Other Expenses	295
Other values (3)	202

Length

Max length	24
Median length	20
Mean length	15.499047
Min length	8

Characters and Unicode

Total characters	2009405
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Contractual Services
2nd row	Contractual Services
3rd row	Contractual Services
4th row	Contractual Services
5th row	Contractual Services

Common Values

Value	Count	Frequency (%)
Contractual Services	76627	59.1%
Supplies	49363	38.1%
Equipment/Capital Outlay	1729	1.3%
Interdepartment Charges	1431	1.1%
Other Expenses	295	0.2%
Personal Services	199	0.2%
Restricted	2	< 0.1%
Interagency Charges	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
services	76826	36.6%
contractual	76627	36.5%
supplies	49363	23.5%
equipment/capital	1729	0.8%
outlay	1729	0.8%
charges	1432	0.7%
interdepartment	1431	0.7%
other	295	0.1%
expenses	295	0.1%
personal	199	0.1%
Other values (2)	3	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	211559	10.5%
t	163034	8.1%
a	161504	8.0%
r	158244	7.9%
c	153456	7.6%
i	129649	6.5%
l	129647	6.5%
u	129448	6.4%
s	128412	6.4%
S	126189	6.3%
Other values (19)	518263	25.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1715736	85.4%
Uppercase Letter	211658	10.5%
Space Separator	80282	4.0%
Other Punctuation	1729	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	211559	12.3%
t	163034	9.5%
a	161504	9.4%
r	158244	9.2%
c	153456	8.9%
i	129649	7.6%
l	129647	7.6%
u	129448	7.5%
s	128412	7.5%
p	103910	6.1%
Other values (10)	246873	14.4%

Uppercase Letter

Value	Count	Frequency (%)
S	126189	59.6%
C	79788	37.7%
E	2024	1.0%
O	2024	1.0%
I	1432	0.7%
P	199	0.1%
R	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	80282	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	1729	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1927394	95.9%
Common	82011	4.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	211559	11.0%
t	163034	8.5%
a	161504	8.4%
r	158244	8.2%
c	153456	8.0%
i	129649	6.7%
l	129647	6.7%
u	129448	6.7%
s	128412	6.7%
S	126189	6.5%
Other values (17)	436252	22.6%

Common

Value	Count	Frequency (%)
	80282	97.9%
/	1729	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2009405	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	211559	10.5%
t	163034	8.1%
a	161504	8.0%
r	158244	7.9%
c	153456	7.6%
i	129649	6.5%
l	129647	6.5%
u	129448	6.4%
s	128412	6.4%
S	126189	6.3%
Other values (19)	518263	25.8%

Sub_Category
Text

Distinct	315
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

Length

Max length	48
Median length	37
Mean length	22.821808
Min length	4

Characters and Unicode

Total characters	2958779
Distinct characters	64
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19 ?
Unique (%)	< 0.1%

Sample

1st row	Payments to Contractors
2nd row	Payments to Contractors
3rd row	Payments to Contractors
4th row	Payments to Contractors
5th row	Payments to Contractors

Value	Count	Frequency (%)
services	38688	11.2%
supplies	33848	9.8%
grant	10974	3.2%
office	10321	3.0%
	9691	2.8%
travel	9521	2.8%
community	8412	2.4%
payments	7853	2.3%
automotive	7789	2.3%
equipment	6975	2.0%
Other values (400)	200964	58.2%

Most occurring characters

Value	Count	Frequency (%)
e	303232	10.2%
i	246091	8.3%
	215389	7.3%
s	191725	6.5%
n	183711	6.2%
t	166618	5.6%
r	165075	5.6%
a	157124	5.3%
o	155660	5.3%
l	134884	4.6%
Other values (54)	1039270	35.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2349791	79.4%
Uppercase Letter	351449	11.9%
Space Separator	215389	7.3%
Other Punctuation	39736	1.3%
Decimal Number	1340	< 0.1%
Dash Punctuation	384	< 0.1%
Open Punctuation	345	< 0.1%
Close Punctuation	345	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	303232	12.9%
i	246091	10.5%
s	191725	8.2%
n	183711	7.8%
t	166618	7.1%
r	165075	7.0%
a	157124	6.7%
o	155660	6.6%
l	134884	5.7%
c	122918	5.2%
Other values (16)	522753	22.2%

Uppercase Letter

Value	Count	Frequency (%)
S	78540	22.3%
C	37641	10.7%
P	29086	8.3%
A	26198	7.5%
T	24255	6.9%
E	24231	6.9%
R	18869	5.4%
O	18362	5.2%
M	16887	4.8%
G	13558	3.9%
Other values (11)	63822	18.2%

Decimal Number

Value	Count	Frequency (%)
2	790	59.0%
0	175	13.1%
1	144	10.7%
4	60	4.5%
3	44	3.3%
8	28	2.1%
9	26	1.9%
7	25	1.9%
5	24	1.8%
6	24	1.8%

Other Punctuation

Value	Count	Frequency (%)
/	24624	62.0%
&	9691	24.4%
,	5421	13.6%

Space Separator

Value	Count	Frequency (%)
	215389	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	384	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	345	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	345	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2701240	91.3%
Common	257539	8.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	303232	11.2%
i	246091	9.1%
s	191725	7.1%
n	183711	6.8%
t	166618	6.2%
r	165075	6.1%
a	157124	5.8%
o	155660	5.8%
l	134884	5.0%
c	122918	4.6%
Other values (37)	874202	32.4%

Common

Value	Count	Frequency (%)
	215389	83.6%
/	24624	9.6%
&	9691	3.8%
,	5421	2.1%
2	790	0.3%
-	384	0.1%
(	345	0.1%
)	345	0.1%
0	175	0.1%
1	144	0.1%
Other values (7)	231	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2958779	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	303232	10.2%
i	246091	8.3%
	215389	7.3%
s	191725	6.5%
n	183711	6.2%
t	166618	5.6%
r	165075	5.6%
a	157124	5.3%
o	155660	5.3%
l	134884	4.6%
Other values (54)	1039270	35.1%

Stimulus_Type
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	129647
Missing (%)	100.0%
Memory size	1013.0 KiB

Funding_Source
Text

Distinct	88
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

Length

Max length	63
Median length	12
Mean length	13.83887
Min length	3

Characters and Unicode

Total characters	1794168
Distinct characters	66
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	< 0.1%

Sample

1st row	Capital Project Fund
2nd row	Capital Project Fund
3rd row	Capital Project Fund
4th row	Capital Project Fund
5th row	Capital Project Fund

Value	Count	Frequency (%)
fund	105809	36.0%
general	101610	34.6%
federally	6333	2.2%
funded	6333	2.2%
thru	5565	1.9%
federal	5408	1.8%
pass	5369	1.8%
other	5276	1.8%
2007	3259	1.1%
year	2857	1.0%
Other values (145)	45983	15.7%

Most occurring characters

Value	Count	Frequency (%)
e	259484	14.5%
n	231733	12.9%
	164155	9.1%
r	137707	7.7%
a	137142	7.6%
d	136527	7.6%
l	128949	7.2%
F	126711	7.1%
u	125558	7.0%
G	105025	5.9%
Other values (56)	241177	13.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1296377	72.3%
Uppercase Letter	305851	17.0%
Space Separator	164155	9.1%
Decimal Number	26998	1.5%
Connector Punctuation	561	< 0.1%
Other Punctuation	119	< 0.1%
Open Punctuation	53	< 0.1%
Close Punctuation	53	< 0.1%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	259484	20.0%
n	231733	17.9%
r	137707	10.6%
a	137142	10.6%
d	136527	10.5%
l	128949	9.9%
u	125558	9.7%
t	25910	2.0%
i	19705	1.5%
s	18503	1.4%
Other values (14)	75159	5.8%

Uppercase Letter

Value	Count	Frequency (%)
F	126711	41.4%
G	105025	34.3%
P	9988	3.3%
C	9736	3.2%
O	8916	2.9%
A	7939	2.6%
T	5661	1.9%
H	4612	1.5%
S	4503	1.5%
Y	3750	1.2%
Other values (13)	19010	6.2%

Decimal Number

Value	Count	Frequency (%)
0	12318	45.6%
2	6737	25.0%
7	3326	12.3%
4	818	3.0%
3	771	2.9%
5	767	2.8%
6	742	2.7%
1	644	2.4%
8	541	2.0%
9	334	1.2%

Other Punctuation

Value	Count	Frequency (%)
/	89	74.8%
'	24	20.2%
&	5	4.2%
.	1	0.8%

Space Separator

Value	Count	Frequency (%)
	164155	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	561	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	53	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	53	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1602228	89.3%
Common	191940	10.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	259484	16.2%
n	231733	14.5%
r	137707	8.6%
a	137142	8.6%
d	136527	8.5%
l	128949	8.0%
F	126711	7.9%
u	125558	7.8%
G	105025	6.6%
t	25910	1.6%
Other values (37)	187482	11.7%

Common

Value	Count	Frequency (%)
	164155	85.5%
0	12318	6.4%
2	6737	3.5%
7	3326	1.7%
4	818	0.4%
3	771	0.4%
5	767	0.4%
6	742	0.4%
1	644	0.3%
_	561	0.3%
Other values (9)	1101	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1794168	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	259484	14.5%
n	231733	12.9%
	164155	9.1%
r	137707	7.7%
a	137142	7.6%
d	136527	7.6%
l	128949	7.2%
F	126711	7.1%
u	125558	7.0%
G	105025	5.9%
Other values (56)	241177	13.4%

Vendor_Name
Text

Distinct	10689
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

Length

Max length	107
Median length	62
Mean length	21.116216
Min length	2

Characters and Unicode

Total characters	2737654
Distinct characters	50
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3981 ?
Unique (%)	3.1%

Sample

1st row	BERGER INC
2nd row	CED INC
3rd row	DINE COMPANY
4th row	DIVERSIFIED SHEET METAL INC
5th row	MARINE INDUSTRIES CORPORATION

Value	Count	Frequency (%)
inc	52349	12.0%
	14548	3.3%
co	7522	1.7%
of	6207	1.4%
group	6125	1.4%
officemax	6073	1.4%
aramark	5795	1.3%
company	5608	1.3%
uniform	5317	1.2%
career	5298	1.2%
Other values (9545)	319964	73.6%

Most occurring characters

Value	Count	Frequency (%)
	305159	11.1%
E	240996	8.8%
A	215908	7.9%
R	201106	7.3%
I	200840	7.3%
N	195502	7.1%
C	171116	6.3%
O	157356	5.7%
S	143952	5.3%
L	135465	4.9%
Other values (40)	770254	28.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2407963	88.0%
Space Separator	305159	11.1%
Other Punctuation	21255	0.8%
Decimal Number	1721	0.1%
Dash Punctuation	1120	< 0.1%
Close Punctuation	216	< 0.1%
Open Punctuation	216	< 0.1%
Connector Punctuation	2	< 0.1%
Math Symbol	1	< 0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	240996	10.0%
A	215908	9.0%
R	201106	8.4%
I	200840	8.3%
N	195502	8.1%
C	171116	7.1%
O	157356	6.5%
S	143952	6.0%
L	135465	5.6%
T	130516	5.4%
Other values (16)	615206	25.5%

Decimal Number

Value	Count	Frequency (%)
4	305	17.7%
2	290	16.9%
0	279	16.2%
1	247	14.4%
3	176	10.2%
9	139	8.1%
7	89	5.2%
5	68	4.0%
8	65	3.8%
6	63	3.7%

Other Punctuation

Value	Count	Frequency (%)
&	19342	91.0%
.	838	3.9%
/	441	2.1%
'	320	1.5%
#	310	1.5%
*	3	< 0.1%
!	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	305159	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1120	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	216	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	216	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	2	100.0%

Math Symbol

Value	Count	Frequency (%)
+	1	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2407963	88.0%
Common	329691	12.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	240996	10.0%
A	215908	9.0%
R	201106	8.4%
I	200840	8.3%
N	195502	8.1%
C	171116	7.1%
O	157356	6.5%
S	143952	6.0%
L	135465	5.6%
T	130516	5.4%
Other values (16)	615206	25.5%

Common

Value	Count	Frequency (%)
	305159	92.6%
&	19342	5.9%
-	1120	0.3%
.	838	0.3%
/	441	0.1%
'	320	0.1%
#	310	0.1%
4	305	0.1%
2	290	0.1%
0	279	0.1%
Other values (14)	1287	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2737654	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	305159	11.1%
E	240996	8.8%
A	215908	7.9%
R	201106	7.3%
I	200840	7.3%
N	195502	7.1%
C	171116	6.3%
O	157356	5.7%
S	143952	5.3%
L	135465	4.9%
Other values (40)	770254	28.1%

InvoiceID
Real number (ℝ)

HIGH CORRELATION

Distinct	111589
Distinct (%)	86.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	637760.8

Minimum	563638
Maximum	708943
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1013.0 KiB

Quantile statistics

Minimum	563638
5-th percentile	579427.3
Q1	605478.5
median	637444
Q3	670010.5
95-th percentile	696517.4
Maximum	708943
Range	145305
Interquartile range (IQR)	64532

Descriptive statistics

Standard deviation	37506.141
Coefficient of variation (CV)	0.058809103
Kurtosis	-1.1756835
Mean	637760.8
Median Absolute Deviation (MAD)	32264
Skewness	0.012801063
Sum	8.2683774 × 10¹⁰
Variance	1.4067106 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
673400	76	0.1%
638608	76	0.1%
608539	69	0.1%
622870	65	0.1%
641713	65	0.1%
651907	65	0.1%
663047	65	0.1%
594748	62	< 0.1%
597775	61	< 0.1%
685077	60	< 0.1%
Other values (111579)	128983	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
563638	1	< 0.1%
567776	1	< 0.1%
567780	1	< 0.1%
567781	1	< 0.1%
567782	1	< 0.1%
567783	1	< 0.1%
567784	1	< 0.1%
567785	1	< 0.1%
567786	1	< 0.1%
567787	1	< 0.1%

Value	Count	Frequency (%)
708943	1	< 0.1%
707170	1	< 0.1%
707071	1	< 0.1%
706799	1	< 0.1%
706798	1	< 0.1%
706759	1	< 0.1%
706651	1	< 0.1%
706649	3	< 0.1%
706646	1	< 0.1%
706644	1	< 0.1%

InvoiceDt
Date

Distinct	781
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

Minimum	2003-01-07 05:00:00+00:00
Maximum	2008-07-18 03:59:59+00:00

Histogram

Histogram with fixed size bins (bins=50)

InvoiceAmt
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	38055
Distinct (%)	29.4%
Missing	8
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	3750.9798

Minimum	-56235.36
Maximum	5000000
Zeros	0
Zeros (%)	0.0%
Negative	1095
Negative (%)	0.8%
Memory size	1013.0 KiB

Quantile statistics

Minimum	-56235.36
5-th percentile	10
Q1	50
median	164.47
Q3	662.5
95-th percentile	9250
Maximum	5000000
Range	5056235.4
Interquartile range (IQR)	612.5

Descriptive statistics

Standard deviation	32691.635
Coefficient of variation (CV)	8.7154921
Kurtosis	5150.0186
Mean	3750.9798
Median Absolute Deviation (MAD)	144.47
Skewness	47.657068
Sum	4.8627327 × 10⁸
Variance	1.068743 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120	2760	2.1%
130	1300	1.0%
25	1156	0.9%
50	1018	0.8%
15	905	0.7%
100	856	0.7%
20	811	0.6%
40	690	0.5%
14.2	655	0.5%
150	641	0.5%
Other values (38045)	118847	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-56235.36	1	< 0.1%
-28512.14	1	< 0.1%
-11101.2	1	< 0.1%
-9158.66	1	< 0.1%
-6874.26	1	< 0.1%
-6508.16	1	< 0.1%
-5148	1	< 0.1%
-4203.59	1	< 0.1%
-4120.5	1	< 0.1%
-3747.91	1	< 0.1%

Value	Count	Frequency (%)
5000000	1	< 0.1%
2538043	2	< 0.1%
2035700	1	< 0.1%
1596051.52	1	< 0.1%
1381943	1	< 0.1%
1378305	2	< 0.1%
1140037	2	< 0.1%
1091653.32	2	< 0.1%
1043127	1	< 0.1%
947187.01	3	< 0.1%

DistributionAmt
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	42543
Distinct (%)	32.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1887.847

Minimum	-131156.92
Maximum	5000000
Zeros	5
Zeros (%)	< 0.1%
Negative	1704
Negative (%)	1.3%
Memory size	1013.0 KiB

Quantile statistics

Minimum	-131156.92
5-th percentile	5.023
Q1	36
median	125
Q3	476.955
95-th percentile	4684
Maximum	5000000
Range	5131156.9
Interquartile range (IQR)	440.955

Descriptive statistics

Standard deviation	22126.235
Coefficient of variation (CV)	11.720354
Kurtosis	21360.233
Mean	1887.847
Median Absolute Deviation (MAD)	110
Skewness	110.28375
Sum	2.447537 × 10⁸
Variance	4.8957028 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120	2856	2.2%
130	1293	1.0%
25	1187	0.9%
15	1069	0.8%
50	1044	0.8%
100	912	0.7%
20	860	0.7%
40	708	0.5%
150	681	0.5%
35	676	0.5%
Other values (42533)	118361	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-131156.92	1	< 0.1%
-110468.7	1	< 0.1%
-109947.76	1	< 0.1%
-81774.08	1	< 0.1%
-56235.36	1	< 0.1%
-50575	1	< 0.1%
-44867.5	1	< 0.1%
-42327.45	1	< 0.1%
-33455.39	1	< 0.1%
-31125.34	1	< 0.1%

Value	Count	Frequency (%)
5000000	1	< 0.1%
2035700	1	< 0.1%
1596051.52	1	< 0.1%
1422811	1	< 0.1%
1381943	1	< 0.1%
1115232	1	< 0.1%
1100000	1	< 0.1%
1043127	1	< 0.1%
1000000	1	< 0.1%
779362.38	1	< 0.1%

CheckID
Real number (ℝ)

HIGH CORRELATION

Distinct	54641
Distinct (%)	42.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	327410.33

Minimum	291142
Maximum	445951
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1013.0 KiB

Quantile statistics

Minimum	291142
5-th percentile	297929
Q1	310301.5
median	327597
Q3	343413.5
95-th percentile	357892
Maximum	445951
Range	154809
Interquartile range (IQR)	33112

Descriptive statistics

Standard deviation	19187.618
Coefficient of variation (CV)	0.058604191
Kurtosis	-1.0990116
Mean	327410.33
Median Absolute Deviation (MAD)	16522
Skewness	0.043037533
Sum	4.2447767 × 10¹⁰
Variance	3.6816467 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
326327	347	0.3%
306051	247	0.2%
306423	228	0.2%
302896	194	0.1%
323123	150	0.1%
351080	139	0.1%
324545	136	0.1%
307984	133	0.1%
346579	133	0.1%
354223	131	0.1%
Other values (54631)	127809	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
291142	2	< 0.1%
291145	1	< 0.1%
291146	1	< 0.1%
291155	1	< 0.1%
291159	1	< 0.1%
291163	1	< 0.1%
291167	1	< 0.1%
291177	1	< 0.1%
291181	1	< 0.1%
291183	1	< 0.1%

Value	Count	Frequency (%)
445951	1	< 0.1%
435745	1	< 0.1%
430959	2	< 0.1%
426021	2	< 0.1%
422260	1	< 0.1%
420189	1	< 0.1%
415041	1	< 0.1%
409644	1	< 0.1%
407728	1	< 0.1%
405618	1	< 0.1%

CheckDt
Date

Distinct	305
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

Minimum	2007-07-03 03:59:59+00:00
Maximum	2009-09-14 03:59:59+00:00

Histogram

Histogram with fixed size bins (bins=50)

CheckAmt
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	24799
Distinct (%)	19.1%
Missing	8
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	10333.631

Minimum	0.4
Maximum	5000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1013.0 KiB

Quantile statistics

Minimum	0.4
5-th percentile	28.75
Q1	211.22
median	1000
Q3	3925
95-th percentile	41707.58
Maximum	5000000
Range	4999999.6
Interquartile range (IQR)	3713.78

Descriptive statistics

Standard deviation	53537.916
Coefficient of variation (CV)	5.1809395
Kurtosis	901.37365
Mean	10333.631
Median Absolute Deviation (MAD)	908.48
Skewness	20.694312
Sum	1.3396416 × 10⁹
Variance	2.8663085 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
120	2488	1.9%
130	1200	0.9%
15	801	0.6%
100	577	0.4%
10	479	0.4%
200	467	0.4%
50	440	0.3%
140	433	0.3%
30896.02	347	0.3%
150	331	0.3%
Other values (24789)	122076	94.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.4	2	< 0.1%
0.8	6	< 0.1%
0.84	1	< 0.1%
0.86	1	< 0.1%
1	1	< 0.1%
1.1	1	< 0.1%
1.2	10	< 0.1%
1.25	1	< 0.1%
1.28	1	< 0.1%
1.35	1	< 0.1%

Value	Count	Frequency (%)
5000000	1	< 0.1%
2538043	2	< 0.1%
2035700	1	< 0.1%
1596051.52	1	< 0.1%
1381943	1	< 0.1%
1378305	2	< 0.1%
1158251	56	< 0.1%
1140037	2	< 0.1%
1130982.01	6	< 0.1%
1111240	54	< 0.1%

CheckVoidDt
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1013.0 KiB

1900/01/01 05:00:00+00	129647

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	2852234
Distinct characters	8
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1900/01/01 05:00:00+00
2nd row	1900/01/01 05:00:00+00
3rd row	1900/01/01 05:00:00+00
4th row	1900/01/01 05:00:00+00
5th row	1900/01/01 05:00:00+00

Common Values

Value	Count	Frequency (%)
1900/01/01 05:00:00+00	129647	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1900/01/01	129647	50.0%
05:00:00+00	129647	50.0%

Most occurring characters

Value	Count	Frequency (%)
0	1426117	50.0%
1	388941	13.6%
/	259294	9.1%
:	259294	9.1%
9	129647	4.5%
	129647	4.5%
5	129647	4.5%
+	129647	4.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2074352	72.7%
Other Punctuation	518588	18.2%
Space Separator	129647	4.5%
Math Symbol	129647	4.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1426117	68.8%
1	388941	18.8%
9	129647	6.2%
5	129647	6.2%

Other Punctuation

Value	Count	Frequency (%)
/	259294	50.0%
:	259294	50.0%

Space Separator

Value	Count	Frequency (%)
	129647	100.0%

Math Symbol

Value	Count	Frequency (%)
+	129647	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2852234	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1426117	50.0%
1	388941	13.6%
/	259294	9.1%
:	259294	9.1%
9	129647	4.5%
	129647	4.5%
5	129647	4.5%
+	129647	4.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2852234	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1426117	50.0%
1	388941	13.6%
/	259294	9.1%
:	259294	9.1%
9	129647	4.5%
	129647	4.5%
5	129647	4.5%
+	129647	4.5%

Auto

Heatmap
Table

	ObjectId	InvoiceID	InvoiceAmt	DistributionAmt	CheckID	CheckAmt	Budget_Type	Agency_Name	Category
ObjectId	1.000	-0.019	-0.039	-0.086	-0.011	0.073	0.843	0.535	0.183
InvoiceID	-0.019	1.000	0.005	0.020	0.998	-0.007	0.073	0.107	0.041
InvoiceAmt	-0.039	0.005	1.000	0.873	0.005	0.577	0.036	0.085	0.017
DistributionAmt	-0.086	0.020	0.873	1.000	0.018	0.489	0.032	0.075	0.015
CheckID	-0.011	0.998	0.005	0.018	1.000	-0.004	0.051	0.063	0.035
CheckAmt	0.073	-0.007	0.577	0.489	-0.004	1.000	0.122	0.083	0.101
Budget_Type	0.843	0.073	0.036	0.032	0.051	0.122	1.000	0.590	0.271
Agency_Name	0.535	0.107	0.085	0.075	0.063	0.083	0.590	1.000	0.381
Category	0.183	0.041	0.017	0.015	0.035	0.101	0.271	0.381	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	ObjectId	Fiscal_Year	Budget_Type	Agency_Name	Sub_Agency_Name	DepartmentName	Sub_DepartmentName	Category	Sub_Category	Stimulus_Type	Funding_Source	Vendor_Name	InvoiceID	InvoiceDt	InvoiceAmt	DistributionAmt	CheckID	CheckDt	CheckAmt	CheckVoidDt
0	1	2008	Metro Government Capital	Waterfront Development Corp	Belle Capital Improvements	NaN	NaN	Contractual Services	Payments to Contractors	NaN	Capital Project Fund	BERGER INC	674183	2008/03/19 03:59:59+00	2944.6	1770.0	346014	2008/05/07 03:59:59+00	2944.6	1900/01/01 05:00:00+00
1	2	2008	Metro Government Capital	Waterfront Development Corp	Belle Capital Improvements	NaN	NaN	Contractual Services	Payments to Contractors	NaN	Capital Project Fund	CED INC	689056	2008/05/07 03:59:59+00	382.1	382.1	354266	2008/06/11 03:59:59+00	282.1	1900/01/01 05:00:00+00
2	3	2008	Metro Government Capital	Waterfront Development Corp	Belle Capital Improvements	NaN	NaN	Contractual Services	Payments to Contractors	NaN	Capital Project Fund	DINE COMPANY	689057	2008/06/03 03:59:59+00	798.0	798.0	354195	2008/06/11 03:59:59+00	1136.3	1900/01/01 05:00:00+00
3	4	2008	Metro Government Capital	Waterfront Development Corp	Belle Capital Improvements	NaN	NaN	Contractual Services	Payments to Contractors	NaN	Capital Project Fund	DIVERSIFIED SHEET METAL INC	689060	2008/05/15 03:59:59+00	1685.0	1685.0	354284	2008/06/11 03:59:59+00	1685.0	1900/01/01 05:00:00+00
4	5	2008	Metro Government Capital	Waterfront Development Corp	Belle Capital Improvements	NaN	NaN	Contractual Services	Payments to Contractors	NaN	Capital Project Fund	MARINE INDUSTRIES CORPORATION	576758	2007/04/10 03:59:59+00	985.0	985.0	299111	2007/08/15 03:59:59+00	985.0	1900/01/01 05:00:00+00
5	6	2008	Metro Government Capital	Waterfront Development Corp	Belle Capital Improvements	NaN	NaN	Contractual Services	Payments to Contractors	NaN	Capital Project Fund	QUANTROL INC	576807	2007/07/16 03:59:59+00	3221.3	2225.0	300614	2007/08/23 03:59:59+00	3221.3	1900/01/01 05:00:00+00
6	7	2008	Metro Government Capital	Waterfront Development Corp	Belle Capital Improvements	NaN	NaN	Contractual Services	Payments to Contractors	NaN	Capital Project Fund	STANLEY SCHULTZE & CO INC	674182	2008/04/14 03:59:59+00	455.0	455.0	345928	2008/05/07 03:59:59+00	455.0	1900/01/01 05:00:00+00
7	8	2008	Metro Government Capital	Waterfront Development Corp	Belle Capital Improvements	NaN	NaN	Contractual Services	Payments to Contractors	NaN	Capital Project Fund	TECHNICAL SERVICE CORPORATION	689059	2008/05/05 03:59:59+00	2000.0	2000.0	354286	2008/06/11 03:59:59+00	2000.0	1900/01/01 05:00:00+00
8	9	2008	Metro Government Capital	Waterfront Development Corp	Belle Capital Improvements	NaN	NaN	Contractual Services	Payments to Contractors	NaN	Capital Project Fund	VITTITOW REFRIGERATION INC.	689033	2008/05/20 03:59:59+00	2925.0	2925.0	355046	2008/06/16 03:59:59+00	2925.0	1900/01/01 05:00:00+00
9	10	2008	Metro Government Capital	Waterfront Development Corp	Belle Capital Improvements	NaN	NaN	Contractual Services	Payments to Contractors	NaN	Capital Project Fund	W M LUMBER AND WOOD PRODUCTS INC	695636	2008/06/10 03:59:59+00	4690.0	3777.9	357641	2008/06/30 03:59:59+00	4690.0	1900/01/01 05:00:00+00

	ObjectId	Fiscal_Year	Budget_Type	Agency_Name	Sub_Agency_Name	DepartmentName	Sub_DepartmentName	Category	Sub_Category	Stimulus_Type	Funding_Source	Vendor_Name	InvoiceID	InvoiceDt	InvoiceAmt	DistributionAmt	CheckID	CheckDt	CheckAmt	CheckVoidDt
129637	129638	2008	Metro Government Operations	Neighborhoods Department	Youth Development	Youth External Fund	NaN	Contractual Services	External Agency Contractual Services	NaN	General Fund	YMCA OF GREATER LOUISVILLE INC	603829	2007/09/06 03:59:59+00	13460.0	13460.0	309208	2007/10/12 03:59:59+00	13460.0	1900/01/01 05:00:00+00
129638	129639	2008	Metro Government Operations	Neighborhoods Department	Youth Development	Youth External Fund	NaN	Contractual Services	External Agency Contractual Services	NaN	General Fund	YMCA OF GREATER LOUISVILLE INC	649179	2008/02/01 05:00:00+00	13700.0	13700.0	332797	2008/02/14 05:00:00+00	13700.0	1900/01/01 05:00:00+00
129639	129640	2008	Metro Government Operations	Neighborhoods Department	Youth Development	Youth External Fund	NaN	Contractual Services	External Agency Contractual Services	NaN	General Fund	YOUNG ADULT DEVELOPMENT IN ACTION INC	627590	2007/11/14 05:00:00+00	14650.0	14650.0	321898	2007/12/11 05:00:00+00	14650.0	1900/01/01 05:00:00+00
129640	129641	2008	Metro Government Operations	Neighborhoods Department	Youth Development	Youth External Fund	NaN	Contractual Services	External Agency Contractual Services	NaN	General Fund	YOUNG ADULT DEVELOPMENT IN ACTION INC	651192	2008/02/14 05:00:00+00	14650.0	14650.0	333988	2008/02/21 05:00:00+00	14650.0	1900/01/01 05:00:00+00
129641	129642	2008	Metro Government Operations	Neighborhoods Department	Youth Development	Youth External Fund	NaN	Contractual Services	External Agency Contractual Services	NaN	General Fund	YOUNG ADULT DEVELOPMENT IN ACTION INC	593688	2007/09/10 03:59:59+00	14600.0	14600.0	304151	2007/09/13 03:59:59+00	14600.0	1900/01/01 05:00:00+00
129642	129643	2008	Metro Government Operations	Neighborhoods Department	Youth Development	Youth External Fund	NaN	Contractual Services	External Agency Contractual Services	NaN	General Fund	YOUNG ADULT DEVELOPMENT IN ACTION INC	675129	2008/04/28 03:59:59+00	14650.0	14650.0	345537	2008/05/05 03:59:59+00	14650.0	1900/01/01 05:00:00+00
129643	129644	2008	Metro Government Operations	Neighborhoods Department	Youth Development	Youth External Fund	NaN	Contractual Services	External Agency Contractual Services	NaN	General Fund	YOUTH ALIVE INC	587006	2007/08/21 03:59:59+00	5875.0	5875.0	301218	2007/08/27 03:59:59+00	5875.0	1900/01/01 05:00:00+00
129644	129645	2008	Metro Government Operations	Neighborhoods Department	Youth Development	Youth External Fund	NaN	Contractual Services	External Agency Contractual Services	NaN	General Fund	YOUTH ALIVE INC	622848	2007/10/19 03:59:59+00	5755.0	5755.0	319685	2007/11/29 05:00:00+00	5755.0	1900/01/01 05:00:00+00
129645	129646	2008	Metro Government Operations	Neighborhoods Department	Youth Development	Youth External Fund	NaN	Contractual Services	External Agency Contractual Services	NaN	General Fund	YOUTH ALIVE INC	649177	2008/02/01 05:00:00+00	5875.0	5875.0	332829	2008/02/14 05:00:00+00	5875.0	1900/01/01 05:00:00+00
129646	129647	2008	Metro Government Operations	Neighborhoods Department	Youth Development	Youth External Fund	NaN	Contractual Services	External Agency Contractual Services	NaN	General Fund	YOUTH ALIVE INC	679330	2008/05/12 03:59:59+00	5875.0	5875.0	347644	2008/05/16 03:59:59+00	5875.0	1900/01/01 05:00:00+00

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common